﻿-- Script n°009: "member" table.
-- @author Clément HELIOU (cheliou@axones.com)
-- @since 1.0

BEGIN;

-- Drop the login unique constraint.
ALTER TABLE member
DROP CONSTRAINT ak_unique_member_login_member;

-- Drop the login column.
ALTER TABLE member
DROP COLUMN login;

-- Create the unique constraint on the email column.
ALTER TABLE member
ADD CONSTRAINT ak_unique_member_email_member UNIQUE (email);

END;
